Report

Dataset statistics

Number of variables	12
Number of observations	15000
Missing cells	3676
Missing cells (%)	2.0%
Duplicate rows	30
Duplicate rows (%)	0.2%
Total size in memory	1.4 MiB
Average record size in memory	96.0 B

Variable types

Numeric	8
Categorical	4

Alerts

Dataset has 30 (0.2%) duplicate rows	Duplicates
`url` has a high cardinality: 13438 distinct values	High cardinality
`make` has a high cardinality: 63 distinct values	High cardinality
`model` has a high cardinality: 524 distinct values	High cardinality
`manufactured` is highly overall correlated with `no_of_owners` and 1 other fields	High correlation
`power` is highly overall correlated with `engine_cap` and 2 other fields	High correlation
`engine_cap` is highly overall correlated with `power` and 2 other fields	High correlation
`curb_weight` is highly overall correlated with `power` and 2 other fields	High correlation
`no_of_owners` is highly overall correlated with `manufactured` and 1 other fields	High correlation
`mileage` is highly overall correlated with `manufactured` and 2 other fields	High correlation
`price` is highly overall correlated with `power` and 2 other fields	High correlation
`make` is highly overall correlated with `engine_cap` and 1 other fields	High correlation
`type_of_vehicle` is highly overall correlated with `make`	High correlation
`url` has 1503 (10.0%) missing values	Missing
`make` has 987 (6.6%) missing values	Missing
`mileage` has 741 (4.9%) missing values	Missing
`price` has 445 (3.0%) missing values	Missing
`url` is uniformly distributed	Uniform

Reproduction

Analysis started	2023-09-02 16:09:20.341548
Analysis finished	2023-09-02 16:09:49.233086
Duration	28.89 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

listing_id
Real number (ℝ)

Distinct	14925
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1011520.4

Minimum	540570
Maximum	1031324
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	117.3 KiB

Quantile statistics

Minimum	540570
5-th percentile	973173.85
Q1	1004436.5
median	1018245.5
Q3	1025465.5
95-th percentile	1030174.1
Maximum	1031324
Range	490754
Interquartile range (IQR)	21029

Descriptive statistics

Standard deviation	22228.693
Coefficient of variation (CV)	0.021975527
Kurtosis	36.663138
Mean	1011520.4
Median Absolute Deviation (MAD)	8885
Skewness	-3.9997439
Sum	1.5172805 × 10¹⁰
Variance	4.9411481 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1014871	3	< 0.1%
1013287	2	< 0.1%
1007571	2	< 0.1%
982101	2	< 0.1%
1025188	2	< 0.1%
1000777	2	< 0.1%
1002390	2	< 0.1%
979943	2	< 0.1%
1021331	2	< 0.1%
1027371	2	< 0.1%
Other values (14915)	14979	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
540570	1	< 0.1%
691782	1	< 0.1%
708011	1	< 0.1%
733385	1	< 0.1%
743986	1	< 0.1%
749258	1	< 0.1%
756142	1	< 0.1%
759456	1	< 0.1%
767227	1	< 0.1%
773433	1	< 0.1%

Value	Count	Frequency (%)
1031324	1	< 0.1%
1031322	1	< 0.1%
1031319	1	< 0.1%
1031316	1	< 0.1%
1031314	1	< 0.1%
1031312	1	< 0.1%
1031310	1	< 0.1%
1031309	1	< 0.1%
1031306	1	< 0.1%
1031305	1	< 0.1%

url
Categorical

HIGH CARDINALITY MISSING UNIFORM

Distinct	13438
Distinct (%)	99.6%
Missing	1503
Missing (%)	10.0%
Memory size	117.3 KiB

https://www.sgcarmart.com/listing/1013488	2
https://www.sgcarmart.com/listing/979943	2
https://www.sgcarmart.com/listing/1029863	2
https://www.sgcarmart.com/listing/1009323	2
https://www.sgcarmart.com/listing/995501	2
Other values (13433)	13487

Length

Max length	41
Median length	41
Mean length	40.800548
Min length	40

Characters and Unicode

Total characters	550685
Distinct characters	27
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	13379 ?
Unique (%)	99.1%

Sample

1st row	https://www.sgcarmart.com/listing/1023911
2nd row	https://www.sgcarmart.com/listing/1022346
3rd row	https://www.sgcarmart.com/listing/1017880
4th row	https://www.sgcarmart.com/listing/1022468
5th row	https://www.sgcarmart.com/listing/1026440

Common Values

Value	Count	Frequency (%)
https://www.sgcarmart.com/listing/1013488	2	< 0.1%
https://www.sgcarmart.com/listing/979943	2	< 0.1%
https://www.sgcarmart.com/listing/1029863	2	< 0.1%
https://www.sgcarmart.com/listing/1009323	2	< 0.1%
https://www.sgcarmart.com/listing/995501	2	< 0.1%
https://www.sgcarmart.com/listing/894308	2	< 0.1%
https://www.sgcarmart.com/listing/992077	2	< 0.1%
https://www.sgcarmart.com/listing/1014871	2	< 0.1%
https://www.sgcarmart.com/listing/1021166	2	< 0.1%
https://www.sgcarmart.com/listing/1027455	2	< 0.1%
Other values (13428)	13477	89.8%
(Missing)	1503	10.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
https://www.sgcarmart.com/listing/1013488	2	< 0.1%
https://www.sgcarmart.com/listing/1023758	2	< 0.1%
https://www.sgcarmart.com/listing/981956	2	< 0.1%
https://www.sgcarmart.com/listing/1020775	2	< 0.1%
https://www.sgcarmart.com/listing/995581	2	< 0.1%
https://www.sgcarmart.com/listing/1024788	2	< 0.1%
https://www.sgcarmart.com/listing/988230	2	< 0.1%
https://www.sgcarmart.com/listing/1021331	2	< 0.1%
https://www.sgcarmart.com/listing/1007674	2	< 0.1%
https://www.sgcarmart.com/listing/996726	2	< 0.1%
Other values (13428)	13477	99.9%

Most occurring characters

Value	Count	Frequency (%)
/	53988	9.8%
t	53988	9.8%
s	40491	7.4%
w	40491	7.4%
i	26994	4.9%
.	26994	4.9%
g	26994	4.9%
c	26994	4.9%
a	26994	4.9%
r	26994	4.9%
Other values (17)	199763	36.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	364419	66.2%
Other Punctuation	94479	17.2%
Decimal Number	91787	16.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	53988	14.8%
s	40491	11.1%
w	40491	11.1%
i	26994	7.4%
g	26994	7.4%
c	26994	7.4%
a	26994	7.4%
r	26994	7.4%
m	26994	7.4%
h	13497	3.7%
Other values (4)	53988	14.8%

Decimal Number

Value	Count	Frequency (%)
1	19024	20.7%
0	18310	19.9%
2	10503	11.4%
9	9283	10.1%
8	6341	6.9%
3	6102	6.6%
7	5852	6.4%
6	5621	6.1%
5	5409	5.9%
4	5342	5.8%

Other Punctuation

Value	Count	Frequency (%)
/	53988	57.1%
.	26994	28.6%
:	13497	14.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	364419	66.2%
Common	186266	33.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	53988	14.8%
s	40491	11.1%
w	40491	11.1%
i	26994	7.4%
g	26994	7.4%
c	26994	7.4%
a	26994	7.4%
r	26994	7.4%
m	26994	7.4%
h	13497	3.7%
Other values (4)	53988	14.8%

Common

Value	Count	Frequency (%)
/	53988	29.0%
.	26994	14.5%
1	19024	10.2%
0	18310	9.8%
:	13497	7.2%
2	10503	5.6%
9	9283	5.0%
8	6341	3.4%
3	6102	3.3%
7	5852	3.1%
Other values (3)	16372	8.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	550685	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
/	53988	9.8%
t	53988	9.8%
s	40491	7.4%
w	40491	7.4%
i	26994	4.9%
.	26994	4.9%
g	26994	4.9%
c	26994	4.9%
a	26994	4.9%
r	26994	4.9%
Other values (17)	199763	36.3%

make
Categorical

HIGH CARDINALITY HIGH CORRELATION MISSING

Distinct	63
Distinct (%)	0.4%
Missing	987
Missing (%)	6.6%
Memory size	117.3 KiB

mercedes-benz	2055
toyota	1868
honda	1801
bmw	1779
audi	729
Other values (58)	5781

Length

Max length	13
Median length	11
Mean length	6.6709484
Min length	2

Characters and Unicode

Total characters	93480
Distinct characters	27
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	14 ?
Unique (%)	0.1%

Sample

1st row	toyota
2nd row	toyota
3rd row	citroen
4th row	renault
5th row	mercedes-benz

Common Values

Value	Count	Frequency (%)
mercedes-benz	2055	13.7%
toyota	1868	12.5%
honda	1801	12.0%
bmw	1779	11.9%
audi	729	4.9%
mazda	608	4.1%
volkswagen	575	3.8%
hyundai	512	3.4%
nissan	462	3.1%
kia	413	2.8%
Other values (53)	3211	21.4%
(Missing)	987	6.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
mercedes-benz	2055	14.5%
toyota	1868	13.2%
honda	1801	12.7%
bmw	1779	12.6%
audi	729	5.2%
mazda	608	4.3%
volkswagen	575	4.1%
hyundai	512	3.6%
nissan	462	3.3%
kia	413	2.9%
Other values (56)	3343	23.6%

Most occurring characters

Value	Count	Frequency (%)
e	10621	11.4%
a	8900	9.5%
o	7679	8.2%
n	6699	7.2%
d	5955	6.4%
s	5829	6.2%
m	5238	5.6%
t	4719	5.0%
b	4656	5.0%
i	4251	4.5%
Other values (17)	28933	31.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	91252	97.6%
Dash Punctuation	2096	2.2%
Space Separator	132	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	10621	11.6%
a	8900	9.8%
o	7679	8.4%
n	6699	7.3%
d	5955	6.5%
s	5829	6.4%
m	5238	5.7%
t	4719	5.2%
b	4656	5.1%
i	4251	4.7%
Other values (15)	26705	29.3%

Dash Punctuation

Value	Count	Frequency (%)
-	2096	100.0%

Space Separator

Value	Count	Frequency (%)
	132	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	91252	97.6%
Common	2228	2.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	10621	11.6%
a	8900	9.8%
o	7679	8.4%
n	6699	7.3%
d	5955	6.5%
s	5829	6.4%
m	5238	5.7%
t	4719	5.2%
b	4656	5.1%
i	4251	4.7%
Other values (15)	26705	29.3%

Common

Value	Count	Frequency (%)
-	2096	94.1%
	132	5.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	93480	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	10621	11.4%
a	8900	9.5%
o	7679	8.2%
n	6699	7.2%
d	5955	6.4%
s	5829	6.2%
m	5238	5.6%
t	4719	5.0%
b	4656	5.0%
i	4251	4.5%
Other values (17)	28933	31.0%

model
Categorical

Distinct	524
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Memory size	117.3 KiB

amg	535
corolla	442
vezel	406
cerato	348
c180	339
Other values (519)	12930

Length

Max length	13
Median length	11
Mean length	4.6742667
Min length	1

Characters and Unicode

Total characters	70114
Distinct characters	37
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	111 ?
Unique (%)	0.7%

Sample

1st row	corolla
2nd row	estima
3rd row	c3
4th row	grand
5th row	e200

Common Values

Value	Count	Frequency (%)
amg	535	3.6%
corolla	442	2.9%
vezel	406	2.7%
cerato	348	2.3%
c180	339	2.3%
2	334	2.2%
civic	329	2.2%
fit	269	1.8%
3	263	1.8%
jazz	255	1.7%
Other values (514)	11480	76.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
amg	535	3.6%
corolla	442	2.9%
vezel	406	2.7%
cerato	348	2.3%
c180	339	2.3%
2	334	2.2%
civic	329	2.2%
fit	269	1.8%
3	263	1.8%
jazz	255	1.7%
Other values (514)	11480	76.5%

Most occurring characters

Value	Count	Frequency (%)
a	7336	10.5%
e	5792	8.3%
r	4867	6.9%
i	4678	6.7%
c	4218	6.0%
o	3902	5.6%
l	3843	5.5%
t	3700	5.3%
s	3132	4.5%
0	3053	4.4%
Other values (27)	25593	36.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	57847	82.5%
Decimal Number	11902	17.0%
Dash Punctuation	365	0.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	7336	12.7%
e	5792	10.0%
r	4867	8.4%
i	4678	8.1%
c	4218	7.3%
o	3902	6.7%
l	3843	6.6%
t	3700	6.4%
s	3132	5.4%
n	2458	4.2%
Other values (16)	13921	24.1%

Decimal Number

Value	Count	Frequency (%)
0	3053	25.7%
2	1814	15.2%
1	1767	14.8%
3	1435	12.1%
8	1169	9.8%
5	1063	8.9%
6	645	5.4%
4	634	5.3%
7	185	1.6%
9	137	1.2%

Dash Punctuation

Value	Count	Frequency (%)
-	365	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	57847	82.5%
Common	12267	17.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	7336	12.7%
e	5792	10.0%
r	4867	8.4%
i	4678	8.1%
c	4218	7.3%
o	3902	6.7%
l	3843	6.6%
t	3700	6.4%
s	3132	5.4%
n	2458	4.2%
Other values (16)	13921	24.1%

Common

Value	Count	Frequency (%)
0	3053	24.9%
2	1814	14.8%
1	1767	14.4%
3	1435	11.7%
8	1169	9.5%
5	1063	8.7%
6	645	5.3%
4	634	5.2%
-	365	3.0%
7	185	1.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	70114	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	7336	10.5%
e	5792	8.3%
r	4867	6.9%
i	4678	6.7%
c	4218	6.0%
o	3902	5.6%
l	3843	5.5%
t	3700	5.3%
s	3132	4.5%
0	3053	4.4%
Other values (27)	25593	36.5%

manufactured
Real number (ℝ)

Distinct	27
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2014.7703

Minimum	1933
Maximum	2021
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	117.3 KiB

Quantile statistics

Minimum	1933
5-th percentile	2008
Q1	2012
median	2016
Q3	2018
95-th percentile	2020
Maximum	2021
Range	88
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.9879627
Coefficient of variation (CV)	0.0019793634
Kurtosis	18.379162
Mean	2014.7703
Median Absolute Deviation (MAD)	2
Skewness	-1.7934879
Sum	30221555
Variance	15.903847
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
2016	2263	15.1%
2018	1901	12.7%
2017	1745	11.6%
2019	1598	10.7%
2015	1427	9.5%
2011	967	6.4%
2008	945	6.3%
2009	702	4.7%
2014	678	4.5%
2020	670	4.5%
Other values (17)	2104	14.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1933	1	< 0.1%
1962	1	< 0.1%
1964	1	< 0.1%
1969	1	< 0.1%
1972	1	< 0.1%
1976	1	< 0.1%
1978	2	< 0.1%
1982	1	< 0.1%
2003	3	< 0.1%
2004	7	< 0.1%

Value	Count	Frequency (%)
2021	113	0.8%
2020	670	4.5%
2019	1598	10.7%
2018	1901	12.7%
2017	1745	11.6%
2016	2263	15.1%
2015	1427	9.5%
2014	678	4.5%
2013	394	2.6%
2012	473	3.2%

type_of_vehicle
Categorical

Distinct	10
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	117.3 KiB

suv	3385
luxury sedan	3119
mid-sized sedan	2554
hatchback	1934
sports car	1919
Other values (5)	2089

Length

Max length	15
Median length	12
Mean length	8.7926667
Min length	3

Characters and Unicode

Total characters	131890
Distinct characters	26
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	mid-sized sedan
2nd row	mpv
3rd row	suv
4th row	mpv
5th row	luxury sedan

Common Values

Value	Count	Frequency (%)
suv	3385	22.6%
luxury sedan	3119	20.8%
mid-sized sedan	2554	17.0%
hatchback	1934	12.9%
sports car	1919	12.8%
mpv	1737	11.6%
stationwagon	345	2.3%
unknown	5	< 0.1%
van	1	< 0.1%
bus/mini bus	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
sedan	5673	25.1%
suv	3385	15.0%
luxury	3119	13.8%
mid-sized	2554	11.3%
hatchback	1934	8.6%
sports	1919	8.5%
car	1919	8.5%
mpv	1737	7.7%
stationwagon	345	1.5%
unknown	5	< 0.1%
Other values (3)	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
s	15797	12.0%
a	12151	9.2%
d	10781	8.2%
u	9630	7.3%
e	8227	6.2%
	7593	5.8%
r	6957	5.3%
n	6380	4.8%
c	5787	4.4%
i	5455	4.1%
Other values (16)	43132	32.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	121742	92.3%
Space Separator	7593	5.8%
Dash Punctuation	2554	1.9%
Other Punctuation	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
s	15797	13.0%
a	12151	10.0%
d	10781	8.9%
u	9630	7.9%
e	8227	6.8%
r	6957	5.7%
n	6380	5.2%
c	5787	4.8%
i	5455	4.5%
v	5123	4.2%
Other values (13)	35454	29.1%

Space Separator

Value	Count	Frequency (%)
	7593	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2554	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	121742	92.3%
Common	10148	7.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	15797	13.0%
a	12151	10.0%
d	10781	8.9%
u	9630	7.9%
e	8227	6.8%
r	6957	5.7%
n	6380	5.2%
c	5787	4.8%
i	5455	4.5%
v	5123	4.2%
Other values (13)	35454	29.1%

Common

Value	Count	Frequency (%)
	7593	74.8%
-	2554	25.2%
/	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	131890	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	15797	12.0%
a	12151	9.2%
d	10781	8.2%
u	9630	7.3%
e	8227	6.2%
	7593	5.8%
r	6957	5.3%
n	6380	4.8%
c	5787	4.4%
i	5455	4.1%
Other values (16)	43132	32.7%

power
Real number (ℝ)

Distinct	257
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	135.80447

Minimum	38
Maximum	735
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	117.3 KiB

Quantile statistics

Minimum	38
5-th percentile	73
Q1	90
median	110
Q3	150
95-th percentile	309
Maximum	735
Range	697
Interquartile range (IQR)	60

Descriptive statistics

Standard deviation	75.927341
Coefficient of variation (CV)	0.5590931
Kurtosis	6.1114279
Mean	135.80447
Median Absolute Deviation (MAD)	25
Skewness	2.3406579
Sum	2037067
Variance	5764.9611
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
90	904	6.0%
135	681	4.5%
96	604	4.0%
115	582	3.9%
85	555	3.7%
80	501	3.3%
88	446	3.0%
100	431	2.9%
73	427	2.8%
92	407	2.7%
Other values (247)	9462	63.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
38	1	< 0.1%
40	2	< 0.1%
45	5	< 0.1%
47	21	0.1%
48	3	< 0.1%
50	2	< 0.1%
51	2	< 0.1%
54	3	< 0.1%
55	1	< 0.1%
57	26	0.2%

Value	Count	Frequency (%)
735	1	< 0.1%
552	3	< 0.1%
545	2	< 0.1%
541	3	< 0.1%
533	2	< 0.1%
530	9	0.1%
515	13	0.1%
507	1	< 0.1%
493	9	0.1%
489	1	< 0.1%

engine_cap
Real number (ℝ)

Distinct	228
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1972.5651

Minimum	647
Maximum	6752
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	117.3 KiB

Quantile statistics

Minimum	647
5-th percentile	1199
Q1	1496
median	1598
Q3	1998
95-th percentile	3696
Maximum	6752
Range	6105
Interquartile range (IQR)	502

Descriptive statistics

Standard deviation	825.76358
Coefficient of variation (CV)	0.41862424
Kurtosis	8.3143575
Mean	1972.5651
Median Absolute Deviation (MAD)	266
Skewness	2.5631736
Sum	29588477
Variance	681885.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1496	1601	10.7%
1998	1106	7.4%
1591	802	5.3%
1598	760	5.1%
1595	690	4.6%
1991	507	3.4%
1499	466	3.1%
1997	446	3.0%
1984	443	3.0%
1498	322	2.1%
Other values (218)	7857	52.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
647	1	< 0.1%
658	2	< 0.1%
659	5	< 0.1%
796	1	< 0.1%
988	5	< 0.1%
989	6	< 0.1%
996	9	0.1%
998	49	0.3%
999	186	1.2%
1086	17	0.1%

Value	Count	Frequency (%)
6752	7	< 0.1%
6749	12	0.1%
6592	30	0.2%
6498	18	0.1%
6262	5	< 0.1%
6208	9	0.1%
5999	3	< 0.1%
5998	32	0.2%
5980	2	< 0.1%
5950	12	0.1%

curb_weight
Real number (ℝ)

Distinct	651
Distinct (%)	4.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1471.6709

Minimum	2
Maximum	2905
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	117.3 KiB

Quantile statistics

Minimum	2
5-th percentile	1068
Q1	1280
median	1430
Q3	1625
95-th percentile	1990
Maximum	2905
Range	2903
Interquartile range (IQR)	345

Descriptive statistics

Standard deviation	283.9995
Coefficient of variation (CV)	0.19297758
Kurtosis	1.2615645
Mean	1471.6709
Median Absolute Deviation (MAD)	180
Skewness	0.84401511
Sum	22075064
Variance	80655.714
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1190	380	2.5%
1430	378	2.5%
1425	250	1.7%
1615	235	1.6%
1345	229	1.5%
1480	225	1.5%
1610	202	1.3%
1310	186	1.2%
1195	186	1.2%
1285	184	1.2%
Other values (641)	12545	83.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	1	< 0.1%
780	1	< 0.1%
786	1	< 0.1%
795	1	< 0.1%
800	3	< 0.1%
805	1	< 0.1%
806	1	< 0.1%
830	1	< 0.1%
840	4	< 0.1%
852	4	< 0.1%

Value	Count	Frequency (%)
2905	1	< 0.1%
2815	5	< 0.1%
2760	2	< 0.1%
2745	2	< 0.1%
2730	1	< 0.1%
2685	3	< 0.1%
2670	1	< 0.1%
2635	3	< 0.1%
2625	1	< 0.1%
2600	2	< 0.1%

no_of_owners
Real number (ℝ)

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.92

Minimum	1
Maximum	6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	117.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	5
Maximum	6
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.2515475
Coefficient of variation (CV)	0.65184765
Kurtosis	1.7059348
Mean	1.92
Median Absolute Deviation (MAD)	0
Skewness	1.50144
Sum	28800
Variance	1.5663711
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	7770	51.8%
2	3675	24.5%
3	1769	11.8%
4	938	6.3%
5	467	3.1%
6	381	2.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	7770	51.8%
2	3675	24.5%
3	1769	11.8%
4	938	6.3%
5	467	3.1%
6	381	2.5%

Value	Count	Frequency (%)
6	381	2.5%
5	467	3.1%
4	938	6.3%
3	1769	11.8%
2	3675	24.5%
1	7770	51.8%

mileage
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	4936
Distinct (%)	34.6%
Missing	741
Missing (%)	4.9%
Infinite	0
Infinite (%)	0.0%
Mean	73664.611

Minimum	1
Maximum	386000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	117.3 KiB

Quantile statistics

Minimum	1
5-th percentile	7000
Q1	35072
median	67444
Q3	105000
95-th percentile	160000
Maximum	386000
Range	385999
Interquartile range (IQR)	69928

Descriptive statistics

Standard deviation	48386.077
Coefficient of variation (CV)	0.65684291
Kurtosis	0.45917871
Mean	73664.611
Median Absolute Deviation (MAD)	33944
Skewness	0.70874696
Sum	1.0503837 × 10⁹
Variance	2.3412125 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
80000	148	1.0%
50000	119	0.8%
120000	118	0.8%
90000	110	0.7%
60000	109	0.7%
130000	104	0.7%
110000	103	0.7%
70000	102	0.7%
65000	93	0.6%
140000	93	0.6%
Other values (4926)	13160	87.7%
(Missing)	741	4.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
8	2	< 0.1%
9	1	< 0.1%
10	2	< 0.1%
11	12	0.1%
12	1	< 0.1%
14	1	< 0.1%
17	1	< 0.1%
18	5	< 0.1%
20	19	0.1%

Value	Count	Frequency (%)
386000	1	< 0.1%
340000	1	< 0.1%
334000	1	< 0.1%
330000	1	< 0.1%
318000	1	< 0.1%
311000	1	< 0.1%
300000	2	< 0.1%
298223	1	< 0.1%
288000	1	< 0.1%
285000	1	< 0.1%

price
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	2630
Distinct (%)	18.1%
Missing	445
Missing (%)	3.0%
Infinite	0
Infinite (%)	0.0%
Mean	108181.28

Minimum	1900
Maximum	2388777
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	117.3 KiB

Quantile statistics

Minimum	1900
5-th percentile	21500
Q1	57800
median	78000
Q3	119800
95-th percentile	271988
Maximum	2388777
Range	2386877
Interquartile range (IQR)	62000

Descriptive statistics

Standard deviation	112136.56
Coefficient of variation (CV)	1.0365616
Kurtosis	47.289295
Mean	108181.28
Median Absolute Deviation (MAD)	26200
Skewness	5.2986911
Sum	1.5745785 × 10⁹
Variance	1.2574607 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
69800	169	1.1%
65800	150	1.0%
58800	130	0.9%
66800	129	0.9%
72800	123	0.8%
68800	121	0.8%
75800	121	0.8%
59800	120	0.8%
76800	119	0.8%
79800	119	0.8%
Other values (2620)	13254	88.4%
(Missing)	445	3.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1900	1	< 0.1%
3500	1	< 0.1%
3999	1	< 0.1%
4800	2	< 0.1%
5000	1	< 0.1%
5300	1	< 0.1%
5500	3	< 0.1%
5800	2	< 0.1%
6000	3	< 0.1%
6300	1	< 0.1%

Value	Count	Frequency (%)
2388777	1	< 0.1%
2000000	1	< 0.1%
1700000	1	< 0.1%
1535555	1	< 0.1%
1480000	1	< 0.1%
1390900	1	< 0.1%
1380500	1	< 0.1%
1330000	1	< 0.1%
1300000	1	< 0.1%
1250000	2	< 0.1%

Auto

Heatmap
Table

	listing_id	manufactured	power	engine_cap	curb_weight	no_of_owners	mileage	price	make	type_of_vehicle
listing_id	1.000	-0.029	-0.068	-0.063	-0.057	0.008	0.048	-0.079	0.148	0.025
manufactured	-0.029	1.000	-0.049	-0.191	0.029	-0.685	-0.826	0.484	0.422	0.376
power	-0.068	-0.049	1.000	0.814	0.799	0.115	-0.064	0.667	0.414	0.284
engine_cap	-0.063	-0.191	0.814	1.000	0.779	0.186	0.079	0.491	0.526	0.252
curb_weight	-0.057	0.029	0.799	0.779	1.000	0.010	-0.074	0.631	0.437	0.266
no_of_owners	0.008	-0.685	0.115	0.186	0.010	1.000	0.573	-0.237	0.151	0.172
mileage	0.048	-0.826	-0.064	0.079	-0.074	0.573	1.000	-0.549	0.092	0.132
price	-0.079	0.484	0.667	0.491	0.631	-0.237	-0.549	1.000	0.456	0.119
make	0.148	0.422	0.414	0.526	0.437	0.151	0.092	0.456	1.000	0.528
type_of_vehicle	0.025	0.376	0.284	0.252	0.266	0.172	0.132	0.119	0.528	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	listing_id	url	make	model	manufactured	type_of_vehicle	power	engine_cap	curb_weight	no_of_owners	mileage	price
0	1023911	https://www.sgcarmart.com/listing/1023911	toyota	corolla	2009	mid-sized sedan	81	1496	1130.0	3	127450.0	20800.0
1	1022346	https://www.sgcarmart.com/listing/1022346	toyota	estima	2007	mpv	125	2362	1710.0	4	103000.0	52500.0
2	1017880	https://www.sgcarmart.com/listing/1017880	citroen	c3	2018	suv	81	1199	1203.0	1	35000.0	68000.0
3	1022468	https://www.sgcarmart.com/listing/1022468	renault	grand	2015	mpv	81	1461	1539.0	1	80848.0	52800.0
4	1026440	https://www.sgcarmart.com/listing/1026440	mercedes-benz	e200	2009	luxury sedan	135	1796	1615.0	2	116199.0	73800.0
5	1019571	https://www.sgcarmart.com/listing/1019571	kia	cerato	2018	mid-sized sedan	93	1591	1287.0	2	22000.0	56800.0
6	1023663	https://www.sgcarmart.com/listing/1023663	toyota	camry	2007	luxury sedan	108	1998	1530.0	4	238400.0	10700.0
7	973358	https://www.sgcarmart.com/listing/973358	bmw	318i	2017	luxury sedan	100	1499	1425.0	1	51400.0	112900.0
8	1024507	https://www.sgcarmart.com/listing/1024507	honda	vezel	2016	suv	96	1496	1190.0	2	72000.0	57800.0
9	1016664	https://www.sgcarmart.com/listing/1016664	honda	civic	2019	mid-sized sedan	92	1597	1237.0	1	27000.0	75800.0

	listing_id	url	make	model	manufactured	type_of_vehicle	power	engine_cap	curb_weight	no_of_owners	mileage	price
14990	985437	https://www.sgcarmart.com/listing/985437	volkswagen	beetle	2010	hatchback	75	1595	1240.0	3	63886.0	88888.0
14991	1004248	https://www.sgcarmart.com/listing/1004248	honda	e	2016	mpv	129	2356	1769.0	1	57600.0	84800.0
14992	974393	https://www.sgcarmart.com/listing/974393	toyota	estima	2010	mpv	125	2362	1780.0	2	151800.0	78800.0
14993	1016298	NaN	hyundai	avante	2009	mid-sized sedan	89	1591	1264.0	4	108665.0	19800.0
14994	1018560	https://www.sgcarmart.com/listing/1018560	toyota	c-hr	2017	suv	90	1797	1440.0	1	58000.0	71800.0
14995	1028368	https://www.sgcarmart.com/listing/1028368	toyota	prius	2018	mpv	100	1798	1500.0	1	53716.0	93800.0
14996	1030303	https://www.sgcarmart.com/listing/1030303	bmw	530i	2017	luxury sedan	185	1998	1540.0	2	56000.0	155000.0
14997	1021704	https://www.sgcarmart.com/listing/1021704	nissan	teana	2008	luxury sedan	134	2496	1565.0	1	103794.0	54800.0
14998	1025480	https://www.sgcarmart.com/listing/1025480	toyota	camry	2011	luxury sedan	123	2362	1540.0	3	149000.0	77800.0
14999	1017540	https://www.sgcarmart.com/listing/1017540	mercedes-benz	c180	2012	luxury sedan	115	1597	1500.0	2	94000.0	81500.0

Most frequently occurring

	listing_id	url	make	model	manufactured	type_of_vehicle	power	engine_cap	curb_weight	no_of_owners	mileage	price	# duplicates
0	894308	https://www.sgcarmart.com/listing/894308	kia	sportage	2017	suv	114	1999	1500.0	1	53708.0	77800.0	2
1	981956	https://www.sgcarmart.com/listing/981956	lexus	rx	2011	suv	138	2672	1840.0	3	118200.0	89800.0	2
2	986149	https://www.sgcarmart.com/listing/986149	lexus	is	2019	luxury sedan	180	1998	1620.0	2	10000.0	149800.0	2
3	991713	https://www.sgcarmart.com/listing/991713	lexus	es	2016	luxury sedan	135	2494	1615.0	1	34900.0	103800.0	2
4	991776	https://www.sgcarmart.com/listing/991776	hyundai	avante	2019	mid-sized sedan	93	1591	1345.0	1	30000.0	71800.0	2
5	992386	https://www.sgcarmart.com/listing/992386	kia	cerato	2017	mid-sized sedan	95	1591	1295.0	2	51240.0	58800.0	2
6	995501	https://www.sgcarmart.com/listing/995501	lexus	rx	2019	suv	175	1998	1890.0	1	31000.0	189800.0	2
7	995581	https://www.sgcarmart.com/listing/995581	bmw	318i	2018	luxury sedan	100	1499	1425.0	1	70000.0	119800.0	2
8	996726	https://www.sgcarmart.com/listing/996726	toyota	c-hr	2018	suv	90	1797	1440.0	1	56214.0	79800.0	2
9	1000777	https://www.sgcarmart.com/listing/1000777	audi	a8	2018	luxury sedan	250	2995	2020.0	1	15200.0	304999.0	2

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Dash Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Space Separator

Dash Punctuation

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring